package org.dao.impl;

import java.sql.ResultSet;

import org.dao.IOrderDao;
import org.util.SqlUtil;


public class OrderDaoImpl implements IOrderDao {

	SqlUtil s=new SqlUtil();



	public ResultSet queryByUName(String uName) {
		String sql = "select oI.ORDERID,GOODSWT,MAILFEE,s.SENDCITY,s.REACHCITY  from ORDERINFO oI "+"inner join SRCITY s on oI.ORDERID=s.ORDERID where oI.ORDERID in (select orderid from myOrder where uName='"+uName+"')";
		ResultSet rs =s.queryUtil(sql);
		return rs ;
	}

}
